Setting general connection properties

This section describes how to configure general connection properties. For an explanation of how to configure advanced connection properties, see Setting advanced connection properties.

To add an IBM Informix source endpoint to Qlik Replicate:

1. In Tasks view, click Manage Endpoint Connections to open the Manage Endpoints Connections dialog box. Then click the New Endpoint Connection button.
2. In the Name field, type a name for your database. This can be any name that will help to identify the database being used.
3. In the Description field, type a description that helps to identify the IBM Informix database. This is optional.

4. Select Source as the database role.

5. Select IBM Informix as the database Type.

   Information note

   When this endpoint is used as a duplicated source in a Log Stream Staging setup, select the Read changes from log stream check box and then select the relevant Log Stream Staging task from the drop-down list.

   For information on setting up and managing Log Stream Staging tasks, see Using the Log Stream.

6. In the Server field, enter the name of the IBM Informix server. On Windows, this must correspond to one of the hosts defined using the setnet32.exe tool. On Linux, this must correspond to a valid dbservername entry in the $INFORMIXDIR/etc/sqlhosts file on the computer running the application.

   Information note

   Consider the following:

   • This information is case sensitive.

   • To determine if you are connected to the database you want to use or if the connection information you entered is correct, click Test Connection.

     If the connection is successful a message in green is displayed. If the connection fails, an error message is displayed at the bottom of the dialog box.

     To view the log entry if the connection fails, click View Log. The server log is displayed with the information for the connection failure. Note that this button is not available unless the test connection fails.

7. Enter the IBM Informix authentication information (User Name, Password) for the authorized user for this IBM Informix database. If you do not know this information, see your IBM Informix database administrator (DBA).

   Information note

   Make sure that the IBM Informix user entered in the IBM Informix Authentication section has the correct access privileges. For information on how to provide the required privileges, see Required permissions.

8. In the Database name field, enter the IBM Informix database name.